Tabela Stock

Definicja tabeli Stock

Name

Stock

Code

Stock

Comment

 


Lista kolumn tabeli Stock

Name

Code

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

Active

Active

StartDT

StartDT

StopDT

StopDT

StockID

StockID

StockTypeID

StockTypeID

StockAccount

StockAccount


Kolumna Code tabeli Stock

Definicja kolumny Code tabeli Stock

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli Stock

Definicja kolumny ShortName tabeli Stock

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli Stock

Definicja kolumny FullName tabeli Stock

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli Stock

Definicja kolumny Description tabeli Stock

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli Stock

Definicja kolumny Active tabeli Stock

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Stock

Definicja kolumny StartDT tabeli Stock

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Stock

Definicja kolumny StopDT tabeli Stock

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna StockID tabeli Stock

Definicja kolumny StockID tabeli Stock

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockTypeID tabeli Stock

Definicja kolumny StockTypeID tabeli Stock

Name

StockTypeID

Code

StockTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockAccount tabeli Stock

Definicja kolumny StockAccount tabeli Stock

Name

StockAccount

Code

StockAccount

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Numer konta ksiegowego zwiazanego z magazynem ("trójki" - potrzebne do eksportu danych do FK)


Lista kluczy tabeli Stock

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Stock

Definicja klucza Identifier_1 tabeli Stock

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment